How to: Link a Word document to a worksheet.
Solution:
Select the cell where the upper-left corner of the Word document should appear. Use the 'Object...' command in the 'Insert' menu to display the 'Object' dialog box. Click the 'Create from File' tab. Type the filename of the Word document, select the 'Link to File' check box, and choose 'OK'.
1) Select the cell where the upper-left corner of the Word document should appear.
2) Select the 'Insert' menu and select 'Object...'. (The Object dialog box appears.)
3) Click 'Create from File' tab.
4) Do one of the following:
a) Type the name of the Word file along with its path in the 'File Name' box.
Typing the filename
b) Locate the path and the filename with the 'Browse...'.
1] Click 'Browse...'. (The Browse dialog box appears.)
the Browse dialog box
2] (Optional) Select the drive where the Word file is located in the 'Look in' drop-down list. (All folders within the selected drive appear.)
3] Select the folder that contains the file. (The folder opens with its files and subfolders.)
4] If the document is located in a subfolder, select the subfolder.
NOTE: If necessary, repeat Step 4)b)4] until the name of the Word file is displayed.
5] Select the name of the Word file.
6] Click 'Insert'. (The path and the filename appear in the File Name box.)
5) Select the 'Link to File' check box.
the Link to File check box
6) Click 'OK'.
